﻿create table dbo.UserofSettings (
   UserSettingId        nvarchar(10)         collate Chinese_PRC_CI_AS not null,
   UserId               nvarchar(30)         collate Chinese_PRC_CI_AS null,
   SettingCodeNo        nvarchar(50)         collate Chinese_PRC_CI_AS null,
   SettingName          nvarchar(50)         collate Chinese_PRC_CI_AS null,
   SettingValue         varchar(20)          collate Chinese_PRC_CI_AS null,
   SettingDescription   nvarchar(150)        collate Chinese_PRC_CI_AS null,
   constraint PK_UserSettings primary key (UserSettingId)
         on "PRIMARY"
)
on "PRIMARY"
go

execute sp_addextendedproperty 'MS_Description', 
   '用户设置ID',
   'user', 'dbo', 'table', 'UserofSettings', 'column', 'UserSettingId'
go

execute sp_addextendedproperty 'MS_Description', 
   '用户ID',
   'user', 'dbo', 'table', 'UserofSettings', 'column', 'UserId'
go

execute sp_addextendedproperty 'MS_Description', 
   '设置编码',
   'user', 'dbo', 'table', 'UserofSettings', 'column', 'SettingCodeNo'
go

execute sp_addextendedproperty 'MS_Description', 
   '设置名称',
   'user', 'dbo', 'table', 'UserofSettings', 'column', 'SettingName'
go

execute sp_addextendedproperty 'MS_Description', 
   '设置值',
   'user', 'dbo', 'table', 'UserofSettings', 'column', 'SettingValue'
go

execute sp_addextendedproperty 'MS_Description', 
   '描述说明',
   'user', 'dbo', 'table', 'UserofSettings', 'column', 'SettingDescription'
go